UCF STIG Viewer Logo
Changes are coming to https://stigviewer.com. Take our survey to help us understand your usage and how we can better serve you in the future.
Take Survey

The audit table should be owned by SYS or SYSTEM.


Overview

Finding ID Version Rule ID IA Controls Severity
V-2515 DO0190-ORACLE11 SV-24859r2_rule Medium
Description
Audit data is frequently targeted by malicious users as it can provide a means to detect their activity. The protection of the audit trail data is of special concern and requires restrictions to allow only the auditor and DBMS backup, recovery, and maintenance users access to it.
STIG Date
Oracle Database 11g Instance STIG 2016-06-15

Details

Check Text ( C-29418r2_chk )
From SQL*Plus:

select owner from dba_tables where table_name = 'AUD$';

If the owner account returned is not SYS or SYSTEM, this is a Finding.

If the AUD$ tables does not exist, this is a Finding.
Fix Text (F-26445r1_fix)
Change the owner of the $AUD table to SYS or SYSTEM account.

OR

Recreate the audit table while logged in as SYS or SYSTEM.